Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
DepositRuleID (PK) | A unique system assigned identifier for the deposit rule | ID_RU_DS | Identity | integer | |
ReturnAgentID (FK) | A unique system assigned identifier for the Return Agent. | ID_AGNT_RTN | Identity | integer | ReturnAgent(PA_AGNT_RTN) |
DepositAmount | The monetary amount of the Deposit that is paid to or collected from the Customer at purchase and return. | MO_DS | MoneyShortRetail | decimal(7,2) | |
DepositPaidOnUnitOfMeasureCode | The unit of measure (e.g. each bottle, each case, each rack, etc.) that the customer pays a deposit on at the time of a sale. | LU_UOM_DS_PD | Code2 | char(2) | |
DepositPaidPerUnitOfMeasureAmount | Th deposit amount paid for each deposit-paid-on-unit-of-measure-code by the consumer at the time an item is purchased. | MO_UOM_DS_PD | Money | decimal(16,5) | |